select f.acc_nbr from bs_tb_serv_identification f where f.serv_id in(
SELECT serv_id
  FROM BS_TB_SERV_LOCATION
 WHERE ADDRESS_ID in
       (select a.address_id
          from bs_tb_address a
         where a.region_id in
               (SELECT REGION_ID
                  FROM BS_TB_REGION
                 START WITH REGION_ID = 152080000000
                CONNECT BY PRIOR REGION_ID = PARENT_REGION_ID)));
                
                
SELECT COUNT(CONTACT_ADDR)
  FROM BS_TB_CUST_CONTACT_INFO
 WHERE CONTACT_ADDR in
       (select a.address_id
          from bs_tb_address a
         where a.region_id in
               (SELECT REGION_ID
                  FROM BS_TB_REGION
                 START WITH REGION_ID = 152080000000
                CONNECT BY PRIOR REGION_ID = PARENT_REGION_ID));
select f.acc_nbr from bs_tb_serv_identification f where f.serv_id in(
SELECT serv_id
  FROM BS_TB_SERV_LOCATION
 WHERE ADDRESS_ID in
       (select a.address_id
          from bs_tb_address a
         where a.region_id in
               (SELECT REGION_ID
                  FROM BS_TB_REGION
                 START WITH REGION_ID = 152080000000
                CONNECT BY PRIOR REGION_ID = PARENT_REGION_ID)));                	

                	 